ControlTransaction

Entity Definition

Logical Name : ControlTransaction
Physical Name : TR_CTL

A type of Transaction that records non-financial activity that tracks changes in the status of a point of sale terminal, terminal access by retail enterprise employees and their supervisors and other activities and events related to the administration and management of the point of sale system.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TransactionID (FK)(PK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN IdentityUUID char(32)
ReasonCode (FK) A unique retailer defined reason code for an action that is taken (or not taken) at a Workstation. e.g. Return reason codes - Past Use By Date, Defective Merchandise, etc. POSNoSale reason Codes - Customer Change Query, Unauthorized Open of the Drawer, etc. CD_RSN Code varchar(20) Reason(CO_CD_RSN)
TypeCode A code that describes the type of control transaction, i.e. period close, etc. .e.g PeriodOpen, PeriodClose, POSStartOfDay, POSEndOfDay, POSNoSale, etc... TY_TRN_CTL Code4 char(4)

Relationships

Parent Entity Verb Phrase Child Entity
Reason classifies ControlTransaction
Transaction can be a ControlTransaction
ControlTransaction can be a POSLockTransaction
ControlTransaction can be a TimePunchTransaction
ControlTransaction can be a TillOperatorAssignmentTransaction
ControlTransaction can be a POSUnlockTransaction
ControlTransaction can be a PasswordAuthorizationTransaction
ControlTransaction can be a POSNoSaleTransaction
ControlTransaction can be a VoidTransaction
ControlTransaction can be a WorkstationPeriodEndTransaction
ControlTransaction can be a TillLimitExceededTransaction
ControlTransaction can be a PeriodOpenTransaction
ControlTransaction can be a TillMovementTransaction
ControlTransaction can be a PeriodCloseTransaction
ControlTransaction can be a StoreSafeTenderSettlementTransaction
ControlTransaction can be a ExternalDepositoryTenderSettlementTransaction
ControlTransaction can be a PasswordChangeTransaction
ControlTransaction can be a TillTenderSettlementTransaction
ControlTransaction can be a WorkstationPeriodStartTransaction
ControlTransaction can be a SignOnTransaction
ControlTransaction can be a SignOffTransaction

Logical Views containing ControlTransaction

Logical View
Logical 01420 - Prepaid and Stored Value Payment Instruments
Logical 02200 - Transaction Macro View
Logical 02400 - Control Transaction Macro View
Logical 02410 - Control Transaction - Sign On Off View
Logical 02420 - Control Transaction - Till Movement View
Logical 02430 - Control Transaction - Period Open Close View
Logical 02440 - Control Transaction - Voids View
Logical 02450 - Control Transaction - Drawer Limit
Logical 02500 - Tender Control Transaction - Macro View
Logical 02520 - Tender Control Transaction - Settlement View
Logical 03130 - Reporting - Store Operations - Session View
Logical 03140 - Reporting - Store Operations - Workstation View
Logical 03150 - Reporting - Store Operations - Operator View
Logical 03160 - Reporting - Store Operations - Till View
Logical 06100 - Calendar View
Logical 06220 - Access Control - Overrides View
Logical 11150 - Worker - Time Punch View